How to: Use the Function Wizard.
Solution:
Select 'Function...' from the 'Insert' menu. Select the function and type its arguments in the appropriate dialog box. Click 'Finish' to insert the function and display the result in the selected cell.
1) Select the cell where the result of the desired function is to be displayed.
2) Select the 'Insert' menu and select 'Function...'. (The Function Wizard - Step 1 of 2 dialog box appears.)
3) Select the desired type of function from the 'Function Category' list box.
NOTE: If unsure of which category to select, select the 'Most Recently Used' or the 'All' category.
4) Select the specific function from the 'Function Name' list box.
Selecting the category and function
NOTE: A description about the function appears at the bottom of the 'Category' list box.
5) Click 'Next'. (The Function Wizard - Step 2 of 2 dialog box appears.)
the Function Wizard Step 2 of 2 dialog box
6) Type arguments in argument boxes.
Typing arguments
NOTE: Additional argument boxes appear if more than one argument is typed. A description for each argument appears as the argument is being typed.
7) Click 'Finish' to insert the function and its arguments and to close the Function Wizard - Step 2 of 2 dialog box. (The result of the function is displayed in the selected cell.)
